About spreadsheets published from Excel
When you publish a spreadsheet from Microsoft Excel, you can open the Web page and make design changes in Microsoft FrontPage or data access page Design view in Microsoft Access. You can also open the Excel worksheet (.xls file) if you saved it, make changes, and republish the spreadsheet to the same Web page. If you didn't save the Excel worksheet, you can export the spreadsheet to Excel, make changes, and either save a copy of the worksheet or publish the changed spreadsheet.
When you publish a spreadsheet from Excel, most of the Excel features are retained and work the same way as in Excel. Features in the following list will work differently or will not be retained when published or saved as a spreadsheet on a Web page.
Excel formulas, functions, and calculation features |
What happens when published or saved as a Web page |
Labels in formulas |
Labels are converted to cell references. |
References to data on other worksheets |
As long as you publish the entire workbook, references to other worksheets publish correctly. If you publish only the referencing worksheet, references to other worksheets are converted to values. |
Subtotals |
Numbers and calculations appear correctly. Group and outline features are not retained. |
1904 date system |
The displayed dates remain the same, but the serial numbers for the dates are converted to the 1900 date system. |
Precision as displayed |
Cell value is published. |
R1C1 reference style |
R1C1 reference style is converted to A1 reference style. |
Excel formatting, graphics, and display features |
What happens when published or saved as a Web page |
Rotated or vertical text |
Rotated or vertical text is converted to horizontal text. |
Distributed alignment |
Not retained. |
Thai alignment |
Not retained. |
Indented text |
Not retained. |
Wrapped text in cells |
Not retained. |
Graphics |
Not retained. |
Pattern fills |
Not retained. |
Dash dot borders |
Dash dot borders are converted to solid borders. |
Multiple fonts in a single cell |
Not retained. The font of the first character in the cell is used. |
Conditional formatting |
Not retained. |
Cell comments |
Not retained. |
Data validation restrictions and messages |
All validation types except Custom and List are retained.
Additionally, cell references in validation rules, custom input messages, and custom error messages are not supported. |
Auditing tracer arrows |
Not retained. |
Outlining |
Collapsed rows are published as hidden. Expanded rows are published normally. |
Printing or page setup features |
Not retained. |
Excel file, sharing, and import features |
What happens when published or saved as a Web page |
Shared workbook information |
Not retained. |
Lotus compatibility |
R1C1 reference style is converted to A1 reference style. |
External data ranges |
Values are published. The ability to refresh from the source data is not retained. |
Web queries |
Values are published. The ability to refresh from the source data is not retained. |
Passwords |
To publish a protected worksheet, you must use a blank (or no) password. |
Excel list and XML List features | What happens when published or saved as a Web page |
---|
Lists | Not retained. |
XML lists | The XML list is retained, but if the list has a totals row, the totals row is not retained. |